﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_InsertUser_BasicReference')
	BEGIN
		DROP  Procedure  [esf_sso].P_InsertUser_BasicReference
	END

GO

CREATE Procedure [esf_sso].P_InsertUser_BasicReference
	@pUserPersonID	INT
	,@pBasicReferenceID	INT
AS

	INSERT INTO [esf_sso].User_BasicReference 
	(UserPersonID, BasicReferenceID)
	VALUES
	(@pUserPersonID, @pBasicReferenceID)

GO

